﻿CREATE TABLE [dbo].[BatchResubmission]
(
    [BatchID]       UNIQUEIDENTIFIER NOT NULL,
	[ResubmissionURI] NVARCHAR(255) NOT NULL,
    [StartDatetime] DATETIME         NULL,
    [EndDatetime]   DATETIME         NULL,
	[Status] NVARCHAR(25) NOT NULL,
    [CreatedBy] NVARCHAR(128) NOT NULL, 
    [CreatedOn] DATETIME NOT NULL, 
    [LastModifiedBy] NVARCHAR(128) NOT NULL, 
    [LastModified] DATETIME NOT NULL DEFAULT GETDATE(), 
    CONSTRAINT [PK_BatchResubmission] PRIMARY KEY ([BatchID])
)
